How to: Copy text from Word to a worksheet text box.
Solution:
Copy text from a Word document using the 'Copy' command, and paste the contents to an Excel text box using the 'Paste' Command.
1) Copy the desired text in Word:
a) Select the desired text.
b) Select the 'Edit' menu and select 'Copy'.
2) Switch to Excel.
3) Open an Excel worksheet.
4) Click 'Text Box' on the 'Drawing' toolbar, to create a text box. (The cursor changes to a cross hair.)
NOTE: If the 'Drawing' toolbar is not available, select the 'View' menu, select 'Toolbars...', select the 'Drawing' check box, and click 'OK'. (The Drawing toolbar appears.)
5) Position the cross hair where text box is to be displayed on the worksheet.
6) Press and hold down the left mouse button.
7) Drag the mouse horizontally and/or vertically. (A rectangular box representing the outline of the text box appears.)
8) Release the left mouse button when the text box is the desired size. (The text box appears on the screen.)
9) Select the 'Edit' menu and select 'Paste'. (The copied text from Word appears in the Excel text box.)
